Tabela SupportingDrugDef

Definicja tabeli SupportingDrugDef

Name

SupportingDrugDef

Code

SupportingDrugDef

Comment

Zestawy leczenia wspomagajacego


Lista kolumn tabeli SupportingDrugDef

Name

Code

SupportingDrugDefID

SupportingDrugDefID

Code

Code

FullName

FullName

Description

Description

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna SupportingDrugDefID tabeli SupportingDrugDef

Definicja kolumny SupportingDrugDefID tabeli SupportingDrugDef

Name

SupportingDrugDefID

Code

SupportingDrugDefID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID zestawu leczenia wspomagajacego


Kolumna Code tabeli SupportingDrugDef

Definicja kolumny Code tabeli SupportingDrugDef

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

Kod schematu


Kolumna FullName tabeli SupportingDrugDef

Definicja kolumny FullName tabeli SupportingDrugDef

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

Nazwa schematu


Kolumna Description tabeli SupportingDrugDef

Definicja kolumny Description tabeli SupportingDrugDef

Name

Description

Code

Description

Data Type

CLOB

Mandatory

No

Comment

Opis schematu


Kolumna StartDT tabeli SupportingDrugDef

Definicja kolumny StartDT tabeli SupportingDrugDef

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data poczatku definicji


Kolumna StopDT tabeli SupportingDrugDef

Definicja kolumny StopDT tabeli SupportingDrugDef

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca definicji


Kolumna Active tabeli SupportingDrugDef

Definicja kolumny Active tabeli SupportingDrugDef

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

Flaga aktywnosci definicji


Lista kluczy tabeli SupportingDrugDef

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli SupportingDrugDef

Definicja klucza Identifier_1 tabeli SupportingDrugDef

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment